using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace SalonPay.DAL
{
    public class pp_Insert_User : SalonPay.DAL.BaseProcedure
    {
        public pp_Insert_User()
        {
            spName = "pp_Insert_User";
            Parameters = new SqlParameter[23];
            Parameters[0] = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
            Parameters[0].Direction = ParameterDirection.Input;
            Parameters[1] = new SqlParameter("@UserPwd", SqlDbType.VarChar, 50);
            Parameters[1].Direction = ParameterDirection.Input;
            Parameters[2] = new SqlParameter("@UTrueName", SqlDbType.VarChar, 50);
            Parameters[2].Direction = ParameterDirection.Input;
            Parameters[3] = new SqlParameter("@UGender", SqlDbType.Int, 4);
            Parameters[3].Direction = ParameterDirection.Input;
            Parameters[4] = new SqlParameter("@UCountry", SqlDbType.VarChar, 50);
            Parameters[4].Direction = ParameterDirection.Input;
            Parameters[5] = new SqlParameter("@UTelNum", SqlDbType.VarChar, 50);
            Parameters[5].Direction = ParameterDirection.Input;
            Parameters[6] = new SqlParameter("@UEmail", SqlDbType.VarChar, 50);
            Parameters[6].Direction = ParameterDirection.Input;
            Parameters[7] = new SqlParameter("@USkype", SqlDbType.VarChar, 50);
            Parameters[7].Direction = ParameterDirection.Input;
            Parameters[8] = new SqlParameter("@UQQ", SqlDbType.VarChar, 50);
            Parameters[8].Direction = ParameterDirection.Input;
            Parameters[9] = new SqlParameter("@UMsn", SqlDbType.VarChar, 50);
            Parameters[9].Direction = ParameterDirection.Input;
            Parameters[10] = new SqlParameter("@UBankName", SqlDbType.VarChar, 50);
            Parameters[10].Direction = ParameterDirection.Input;
            Parameters[11] = new SqlParameter("@UBankArea", SqlDbType.VarChar, 50);
            Parameters[11].Direction = ParameterDirection.Input;
            Parameters[12] = new SqlParameter("@UBankCard", SqlDbType.VarChar, 50);
            Parameters[12].Direction = ParameterDirection.Input;
            Parameters[13] = new SqlParameter("@UBankType", SqlDbType.VarChar, 50);
            Parameters[13].Direction = ParameterDirection.Input;
            Parameters[14] = new SqlParameter("@UDrawPwd", SqlDbType.VarChar, 50);
            Parameters[14].Direction = ParameterDirection.Input;
            Parameters[15] = new SqlParameter("@URegDate", SqlDbType.DateTime, 8);
            Parameters[15].Direction = ParameterDirection.Input;
            Parameters[16] = new SqlParameter("@URegIp", SqlDbType.VarChar, 50);
            Parameters[16].Direction = ParameterDirection.Input;
            Parameters[17] = new SqlParameter("@UTeleType", SqlDbType.Int, 4);
            Parameters[17].Direction = ParameterDirection.Input;
            Parameters[18] = new SqlParameter("@UTeleContent", SqlDbType.VarChar, 50);
            Parameters[18].Direction = ParameterDirection.Input;
            Parameters[19] = new SqlParameter("@UPusher", SqlDbType.VarChar, 50);
            Parameters[19].Direction = ParameterDirection.Input;
            Parameters[20] = new SqlParameter("@ULobby", SqlDbType.VarChar, 50);
            Parameters[20].Direction = ParameterDirection.Input;
            Parameters[21] = new SqlParameter("@UClubType", SqlDbType.VarChar, 50);
            Parameters[21].Direction = ParameterDirection.Input;
            Parameters[22] = new SqlParameter("@Result", SqlDbType.Int, 4);
            Parameters[22].Direction = ParameterDirection.Output;

        }
        public pp_Insert_User(string _userName, string _userPwd, string _uTrueName, Int32 _uGender, string _uCountry, string _uTelNum, string _uEmail, string _uSkype, string _uQQ, string _uMsn, string _uBankName, string _uBankArea, string _uBankCard, string _uBankType, string _uDrawPwd, DateTime _uRegDate, string _uRegIp, Int32 _uTeleType, string _uTeleContent, string _uPusher, string _uLobby, string _uClubType)
        {
            spName = "pp_Insert_User";
            Parameters = new SqlParameter[23];
            Parameters[0] = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
            Parameters[0].Direction = ParameterDirection.Input;
            Parameters[0].Value = _userName;
            Parameters[1] = new SqlParameter("@UserPwd", SqlDbType.VarChar, 50);
            Parameters[1].Direction = ParameterDirection.Input;
            Parameters[1].Value = _userPwd;
            Parameters[2] = new SqlParameter("@UTrueName", SqlDbType.VarChar, 50);
            Parameters[2].Direction = ParameterDirection.Input;
            Parameters[2].Value = _uTrueName;
            Parameters[3] = new SqlParameter("@UGender", SqlDbType.Int, 4);
            Parameters[3].Direction = ParameterDirection.Input;
            Parameters[3].Value = _uGender;
            Parameters[4] = new SqlParameter("@UCountry", SqlDbType.VarChar, 50);
            Parameters[4].Direction = ParameterDirection.Input;
            Parameters[4].Value = _uCountry;
            Parameters[5] = new SqlParameter("@UTelNum", SqlDbType.VarChar, 50);
            Parameters[5].Direction = ParameterDirection.Input;
            Parameters[5].Value = _uTelNum;
            Parameters[6] = new SqlParameter("@UEmail", SqlDbType.VarChar, 50);
            Parameters[6].Direction = ParameterDirection.Input;
            Parameters[6].Value = _uEmail;
            Parameters[7] = new SqlParameter("@USkype", SqlDbType.VarChar, 50);
            Parameters[7].Direction = ParameterDirection.Input;
            Parameters[7].Value = _uSkype;
            Parameters[8] = new SqlParameter("@UQQ", SqlDbType.VarChar, 50);
            Parameters[8].Direction = ParameterDirection.Input;
            Parameters[8].Value = _uQQ;
            Parameters[9] = new SqlParameter("@UMsn", SqlDbType.VarChar, 50);
            Parameters[9].Direction = ParameterDirection.Input;
            Parameters[9].Value = _uMsn;
            Parameters[10] = new SqlParameter("@UBankName", SqlDbType.VarChar, 50);
            Parameters[10].Direction = ParameterDirection.Input;
            Parameters[10].Value = _uBankName;
            Parameters[11] = new SqlParameter("@UBankArea", SqlDbType.VarChar, 50);
            Parameters[11].Direction = ParameterDirection.Input;
            Parameters[11].Value = _uBankArea;
            Parameters[12] = new SqlParameter("@UBankCard", SqlDbType.VarChar, 50);
            Parameters[12].Direction = ParameterDirection.Input;
            Parameters[12].Value = _uBankCard;
            Parameters[13] = new SqlParameter("@UBankType", SqlDbType.VarChar, 50);
            Parameters[13].Direction = ParameterDirection.Input;
            Parameters[13].Value = _uBankType;
            Parameters[14] = new SqlParameter("@UDrawPwd", SqlDbType.VarChar, 50);
            Parameters[14].Direction = ParameterDirection.Input;
            Parameters[14].Value = _uDrawPwd;
            Parameters[15] = new SqlParameter("@URegDate", SqlDbType.DateTime, 8);
            Parameters[15].Direction = ParameterDirection.Input;
            Parameters[15].Value = _uRegDate;
            Parameters[16] = new SqlParameter("@URegIp", SqlDbType.VarChar, 50);
            Parameters[16].Direction = ParameterDirection.Input;
            Parameters[16].Value = _uRegIp;
            Parameters[17] = new SqlParameter("@UTeleType", SqlDbType.Int, 4);
            Parameters[17].Direction = ParameterDirection.Input;
            Parameters[17].Value = _uTeleType;
            Parameters[18] = new SqlParameter("@UTeleContent", SqlDbType.VarChar, 50);
            Parameters[18].Direction = ParameterDirection.Input;
            Parameters[18].Value = _uTeleContent;
            Parameters[19] = new SqlParameter("@UPusher", SqlDbType.VarChar, 50);
            Parameters[19].Direction = ParameterDirection.Input;
            Parameters[19].Value = _uPusher;
            Parameters[20] = new SqlParameter("@ULobby", SqlDbType.VarChar, 50);
            Parameters[20].Direction = ParameterDirection.Input;
            Parameters[20].Value = _uLobby;
            Parameters[21] = new SqlParameter("@UClubType", SqlDbType.VarChar, 50);
            Parameters[21].Direction = ParameterDirection.Input;
            Parameters[21].Value = _uClubType;
            Parameters[22] = new SqlParameter("@Result", SqlDbType.Int, 4);
            Parameters[22].Direction = ParameterDirection.Output;
        }
        public string UserName
        {
            get
            {
                return (Parameters[0].Value is DBNull ? null : Parameters[0].Value) as string;
            }
            set
            {
                Parameters[0].Value = value;
            }
        }
        public string UserPwd
        {
            get
            {
                return (Parameters[1].Value is DBNull ? null : Parameters[1].Value) as string;
            }
            set
            {
                Parameters[1].Value = value;
            }
        }
        public string UTrueName
        {
            get
            {
                return (Parameters[2].Value is DBNull ? null : Parameters[2].Value) as string;
            }
            set
            {
                Parameters[2].Value = value;
            }
        }
        public Int32 UGender
        {
            get
            {
                return Convert.ToInt32(Parameters[3].Value is DBNull ? null : Parameters[3].Value);
            }
            set
            {
                Parameters[3].Value = value;
            }
        }
        public string UCountry
        {
            get
            {
                return (Parameters[4].Value is DBNull ? null : Parameters[4].Value) as string;
            }
            set
            {
                Parameters[4].Value = value;
            }
        }
        public string UTelNum
        {
            get
            {
                return (Parameters[5].Value is DBNull ? null : Parameters[5].Value) as string;
            }
            set
            {
                Parameters[5].Value = value;
            }
        }
        public string UEmail
        {
            get
            {
                return (Parameters[6].Value is DBNull ? null : Parameters[6].Value) as string;
            }
            set
            {
                Parameters[6].Value = value;
            }
        }
        public string USkype
        {
            get
            {
                return (Parameters[7].Value is DBNull ? null : Parameters[7].Value) as string;
            }
            set
            {
                Parameters[7].Value = value;
            }
        }
        public string UQQ
        {
            get
            {
                return (Parameters[8].Value is DBNull ? null : Parameters[8].Value) as string;
            }
            set
            {
                Parameters[8].Value = value;
            }
        }
        public string UMsn
        {
            get
            {
                return (Parameters[9].Value is DBNull ? null : Parameters[9].Value) as string;
            }
            set
            {
                Parameters[9].Value = value;
            }
        }
        public string UBankName
        {
            get
            {
                return (Parameters[10].Value is DBNull ? null : Parameters[10].Value) as string;
            }
            set
            {
                Parameters[10].Value = value;
            }
        }
        public string UBankArea
        {
            get
            {
                return (Parameters[11].Value is DBNull ? null : Parameters[11].Value) as string;
            }
            set
            {
                Parameters[11].Value = value;
            }
        }
        public string UBankCard
        {
            get
            {
                return (Parameters[12].Value is DBNull ? null : Parameters[12].Value) as string;
            }
            set
            {
                Parameters[12].Value = value;
            }
        }
        public string UBankType
        {
            get
            {
                return (Parameters[13].Value is DBNull ? null : Parameters[13].Value) as string;
            }
            set
            {
                Parameters[13].Value = value;
            }
        }
        public string UDrawPwd
        {
            get
            {
                return (Parameters[14].Value is DBNull ? null : Parameters[14].Value) as string;
            }
            set
            {
                Parameters[14].Value = value;
            }
        }
        public DateTime URegDate
        {
            get
            {
                return Convert.ToDateTime((Parameters[15].Value is DBNull ? null : Parameters[15].Value));
            }
            set
            {
                Parameters[15].Value = value;
            }
        }
        public string URegIp
        {
            get
            {
                return (Parameters[16].Value is DBNull ? null : Parameters[16].Value) as string;
            }
            set
            {
                Parameters[16].Value = value;
            }
        }
        public Int32 UTeleType
        {
            get
            {
                return Convert.ToInt32(Parameters[17].Value is DBNull ? null : Parameters[17].Value);
            }
            set
            {
                Parameters[17].Value = value;
            }
        }
        public string UTeleContent
        {
            get
            {
                return (Parameters[18].Value is DBNull ? null : Parameters[18].Value) as string;
            }
            set
            {
                Parameters[18].Value = value;
            }
        }
        public string UPusher
        {
            get
            {
                return (Parameters[19].Value is DBNull ? null : Parameters[19].Value) as string;
            }
            set
            {
                Parameters[19].Value = value;
            }
        }
        public string ULobby
        {
            get
            {
                return (Parameters[20].Value is DBNull ? null : Parameters[20].Value) as string;
            }
            set
            {
                Parameters[20].Value = value;
            }
        }
        public string UClubType
        {
            get
            {
                return (Parameters[21].Value is DBNull ? null : Parameters[21].Value) as string;
            }
            set
            {
                Parameters[21].Value = value;
            }
        }
        public Int32 Result
        {
            get
            {
                return Convert.ToInt32(Parameters[22].Value is DBNull ? null : Parameters[22].Value);
            }
            set
            {
                Parameters[22].Value = value;
            }
        }

    }

    public class pp_Insert_Order : SalonPay.DAL.BaseProcedure
    {
        public pp_Insert_Order()
        {
            spName = "pp_Insert_Order";
            Parameters = new SqlParameter[15];
            Parameters[0] = new SqlParameter("@OrderId", SqlDbType.VarChar, 50);
            Parameters[0].Direction = ParameterDirection.Input;
            Parameters[1] = new SqlParameter("@OPayGateWayType", SqlDbType.Int, 4);
            Parameters[1].Direction = ParameterDirection.Input;
            Parameters[2] = new SqlParameter("@OPayType", SqlDbType.Int, 4);
            Parameters[2].Direction = ParameterDirection.Input;
            Parameters[3] = new SqlParameter("@OLanguage", SqlDbType.Int, 4);
            Parameters[3].Direction = ParameterDirection.Input;
            Parameters[4] = new SqlParameter("@OUserName", SqlDbType.VarChar, 50);
            Parameters[4].Direction = ParameterDirection.Input;
            Parameters[5] = new SqlParameter("@OTrueName", SqlDbType.VarChar, 50);
            Parameters[5].Direction = ParameterDirection.Input;
            Parameters[6] = new SqlParameter("@OPhone", SqlDbType.VarChar, 50);
            Parameters[6].Direction = ParameterDirection.Input;
            Parameters[7] = new SqlParameter("@OEmail", SqlDbType.VarChar, 50);
            Parameters[7].Direction = ParameterDirection.Input;
            Parameters[8] = new SqlParameter("@OAmount", SqlDbType.Int, 4);
            Parameters[8].Direction = ParameterDirection.Input;
            Parameters[9] = new SqlParameter("@OMoneyType", SqlDbType.VarChar, 50);
            Parameters[9].Direction = ParameterDirection.Input;
            Parameters[10] = new SqlParameter("@OPayIp", SqlDbType.VarChar, 50);
            Parameters[10].Direction = ParameterDirection.Input;
            Parameters[11] = new SqlParameter("@OPayDate", SqlDbType.DateTime, 8);
            Parameters[11].Direction = ParameterDirection.Input;
            Parameters[12] = new SqlParameter("@OMemoText", SqlDbType.VarChar, 100);
            Parameters[12].Direction = ParameterDirection.Input;
            Parameters[13] = new SqlParameter("@OClubType", SqlDbType.VarChar, 50);
            Parameters[13].Direction = ParameterDirection.Input;
            Parameters[14] = new SqlParameter("@Result", SqlDbType.Int, 4);
            Parameters[14].Direction = ParameterDirection.Output;

        }
        public pp_Insert_Order(string _orderId, Int32 _oPayGateWayType, Int32 _oPayType, Int32 _oLanguage, string _oUserName, string _oTrueName, string _oPhone, string _oEmail, Int32 _oAmount, string _oMoneyType, string _oPayIp, DateTime _oPayDate, string _oMemoText, string _oClubType)
        {
            spName = "pp_Insert_Order";
            Parameters = new SqlParameter[15];
            Parameters[0] = new SqlParameter("@OrderId", SqlDbType.VarChar, 50);
            Parameters[0].Direction = ParameterDirection.Input;
            Parameters[0].Value = _orderId;
            Parameters[1] = new SqlParameter("@OPayGateWayType", SqlDbType.Int, 4);
            Parameters[1].Direction = ParameterDirection.Input;
            Parameters[1].Value = _oPayGateWayType;
            Parameters[2] = new SqlParameter("@OPayType", SqlDbType.Int, 4);
            Parameters[2].Direction = ParameterDirection.Input;
            Parameters[2].Value = _oPayType;
            Parameters[3] = new SqlParameter("@OLanguage", SqlDbType.Int, 4);
            Parameters[3].Direction = ParameterDirection.Input;
            Parameters[3].Value = _oLanguage;
            Parameters[4] = new SqlParameter("@OUserName", SqlDbType.VarChar, 50);
            Parameters[4].Direction = ParameterDirection.Input;
            Parameters[4].Value = _oUserName;
            Parameters[5] = new SqlParameter("@OTrueName", SqlDbType.VarChar, 50);
            Parameters[5].Direction = ParameterDirection.Input;
            Parameters[5].Value = _oTrueName;
            Parameters[6] = new SqlParameter("@OPhone", SqlDbType.VarChar, 50);
            Parameters[6].Direction = ParameterDirection.Input;
            Parameters[6].Value = _oPhone;
            Parameters[7] = new SqlParameter("@OEmail", SqlDbType.VarChar, 50);
            Parameters[7].Direction = ParameterDirection.Input;
            Parameters[7].Value = _oEmail;
            Parameters[8] = new SqlParameter("@OAmount", SqlDbType.Int, 4);
            Parameters[8].Direction = ParameterDirection.Input;
            Parameters[8].Value = _oAmount;
            Parameters[9] = new SqlParameter("@OMoneyType", SqlDbType.VarChar, 50);
            Parameters[9].Direction = ParameterDirection.Input;
            Parameters[9].Value = _oMoneyType;
            Parameters[10] = new SqlParameter("@OPayIp", SqlDbType.VarChar, 50);
            Parameters[10].Direction = ParameterDirection.Input;
            Parameters[10].Value = _oPayIp;
            Parameters[11] = new SqlParameter("@OPayDate", SqlDbType.DateTime, 8);
            Parameters[11].Direction = ParameterDirection.Input;
            Parameters[11].Value = _oPayDate;
            Parameters[12] = new SqlParameter("@OMemoText", SqlDbType.VarChar, 100);
            Parameters[12].Direction = ParameterDirection.Input;
            Parameters[12].Value = _oMemoText;
            Parameters[13] = new SqlParameter("@OClubType", SqlDbType.VarChar, 50);
            Parameters[13].Direction = ParameterDirection.Input;
            Parameters[13].Value = _oClubType;
            Parameters[14] = new SqlParameter("@Result", SqlDbType.Int, 4);
            Parameters[14].Direction = ParameterDirection.Output;
        }
        public string OrderId
        {
            get
            {
                return (Parameters[0].Value is DBNull ? null : Parameters[0].Value) as string;
            }
            set
            {
                Parameters[0].Value = value;
            }
        }
        public Int32 OPayGateWayType
        {
            get
            {
                return Convert.ToInt32(Parameters[1].Value is DBNull ? null : Parameters[1].Value);
            }
            set
            {
                Parameters[1].Value = value;
            }
        }
        public Int32 OPayType
        {
            get
            {
                return Convert.ToInt32(Parameters[2].Value is DBNull ? null : Parameters[2].Value);
            }
            set
            {
                Parameters[2].Value = value;
            }
        }
        public Int32 OLanguage
        {
            get
            {
                return Convert.ToInt32(Parameters[3].Value is DBNull ? null : Parameters[3].Value);
            }
            set
            {
                Parameters[3].Value = value;
            }
        }
        public string OUserName
        {
            get
            {
                return (Parameters[4].Value is DBNull ? null : Parameters[4].Value) as string;
            }
            set
            {
                Parameters[4].Value = value;
            }
        }
        public string OTrueName
        {
            get
            {
                return (Parameters[5].Value is DBNull ? null : Parameters[5].Value) as string;
            }
            set
            {
                Parameters[5].Value = value;
            }
        }
        public string OPhone
        {
            get
            {
                return (Parameters[6].Value is DBNull ? null : Parameters[6].Value) as string;
            }
            set
            {
                Parameters[6].Value = value;
            }
        }
        public string OEmail
        {
            get
            {
                return (Parameters[7].Value is DBNull ? null : Parameters[7].Value) as string;
            }
            set
            {
                Parameters[7].Value = value;
            }
        }
        public Int32 OAmount
        {
            get
            {
                return Convert.ToInt32(Parameters[8].Value is DBNull ? null : Parameters[8].Value);
            }
            set
            {
                Parameters[8].Value = value;
            }
        }
        public string OMoneyType
        {
            get
            {
                return (Parameters[9].Value is DBNull ? null : Parameters[9].Value) as string;
            }
            set
            {
                Parameters[9].Value = value;
            }
        }
        public string OPayIp
        {
            get
            {
                return (Parameters[10].Value is DBNull ? null : Parameters[10].Value) as string;
            }
            set
            {
                Parameters[10].Value = value;
            }
        }
        public DateTime OPayDate
        {
            get
            {
                return Convert.ToDateTime((Parameters[11].Value is DBNull ? null : Parameters[11].Value));
            }
            set
            {
                Parameters[11].Value = value;
            }
        }
        public string OMemoText
        {
            get
            {
                return (Parameters[12].Value is DBNull ? null : Parameters[12].Value) as string;
            }
            set
            {
                Parameters[12].Value = value;
            }
        }
        public string OClubType
        {
            get
            {
                return (Parameters[13].Value is DBNull ? null : Parameters[13].Value) as string;
            }
            set
            {
                Parameters[13].Value = value;
            }
        }
        public Int32 Result
        {
            get
            {
                return Convert.ToInt32(Parameters[14].Value is DBNull ? null : Parameters[14].Value);
            }
            set
            {
                Parameters[14].Value = value;
            }
        }

    }

    public class pp_Get_Order_ByStatus : SalonPay.DAL.BaseProcedure
    {
        public pp_Get_Order_ByStatus()
        {
            spName = "pp_Get_Order_ByStatus";
            Parameters = new SqlParameter[1];
            Parameters[0] = new SqlParameter("@Status", SqlDbType.Int, 4);
            Parameters[0].Direction = ParameterDirection.Input;

        }
        public pp_Get_Order_ByStatus(Int32 _status)
        {
            spName = "pp_Get_Order_ByStatus";
            Parameters = new SqlParameter[1];
            Parameters[0] = new SqlParameter("@Status", SqlDbType.Int, 4);
            Parameters[0].Direction = ParameterDirection.Input;
            Parameters[0].Value = _status;
        }
        public Int32 Status
        {
            get
            {
                return Convert.ToInt32(Parameters[0].Value is DBNull ? null : Parameters[0].Value);
            }
            set
            {
                Parameters[0].Value = value;
            }
        }

    }

    public class pp_Insert_ChargeLog : SalonPay.DAL.BaseProcedure
    {
        public pp_Insert_ChargeLog()
        {
            spName = "pp_Insert_ChargeLog";
            Parameters = new SqlParameter[6];
            Parameters[0] = new SqlParameter("@LOrderId", SqlDbType.VarChar, 50);
            Parameters[0].Direction = ParameterDirection.Input;
            Parameters[1] = new SqlParameter("@LOrderAmount", SqlDbType.Int, 4);
            Parameters[1].Direction = ParameterDirection.Input;
            Parameters[2] = new SqlParameter("@LUserName", SqlDbType.VarChar, 50);
            Parameters[2].Direction = ParameterDirection.Input;
            Parameters[3] = new SqlParameter("@LChargeStatus", SqlDbType.Int, 4);
            Parameters[3].Direction = ParameterDirection.Input;
            Parameters[4] = new SqlParameter("@LChargeResult", SqlDbType.VarChar, 200);
            Parameters[4].Direction = ParameterDirection.Input;
            Parameters[5] = new SqlParameter("@LChargeType", SqlDbType.VarChar, 50);
            Parameters[5].Direction = ParameterDirection.Input;

        }
        public pp_Insert_ChargeLog(string _lOrderId, Int32 _lOrderAmount, string _lUserName, Int32 _lChargeStatus, string _lChargeResult, string _lChargeType)
        {
            spName = "pp_Insert_ChargeLog";
            Parameters = new SqlParameter[6];
            Parameters[0] = new SqlParameter("@LOrderId", SqlDbType.VarChar, 50);
            Parameters[0].Direction = ParameterDirection.Input;
            Parameters[0].Value = _lOrderId;
            Parameters[1] = new SqlParameter("@LOrderAmount", SqlDbType.Int, 4);
            Parameters[1].Direction = ParameterDirection.Input;
            Parameters[1].Value = _lOrderAmount;
            Parameters[2] = new SqlParameter("@LUserName", SqlDbType.VarChar, 50);
            Parameters[2].Direction = ParameterDirection.Input;
            Parameters[2].Value = _lUserName;
            Parameters[3] = new SqlParameter("@LChargeStatus", SqlDbType.Int, 4);
            Parameters[3].Direction = ParameterDirection.Input;
            Parameters[3].Value = _lChargeStatus;
            Parameters[4] = new SqlParameter("@LChargeResult", SqlDbType.VarChar, 200);
            Parameters[4].Direction = ParameterDirection.Input;
            Parameters[4].Value = _lChargeResult;
            Parameters[5] = new SqlParameter("@LChargeType", SqlDbType.VarChar, 50);
            Parameters[5].Direction = ParameterDirection.Input;
            Parameters[5].Value = _lChargeType;
        }
        public string LOrderId
        {
            get
            {
                return (Parameters[0].Value is DBNull ? null : Parameters[0].Value) as string;
            }
            set
            {
                Parameters[0].Value = value;
            }
        }
        public Int32 LOrderAmount
        {
            get
            {
                return Convert.ToInt32(Parameters[1].Value is DBNull ? null : Parameters[1].Value);
            }
            set
            {
                Parameters[1].Value = value;
            }
        }
        public string LUserName
        {
            get
            {
                return (Parameters[2].Value is DBNull ? null : Parameters[2].Value) as string;
            }
            set
            {
                Parameters[2].Value = value;
            }
        }
        public Int32 LChargeStatus
        {
            get
            {
                return Convert.ToInt32(Parameters[3].Value is DBNull ? null : Parameters[3].Value);
            }
            set
            {
                Parameters[3].Value = value;
            }
        }
        public string LChargeResult
        {
            get
            {
                return (Parameters[4].Value is DBNull ? null : Parameters[4].Value) as string;
            }
            set
            {
                Parameters[4].Value = value;
            }
        }
        public string LChargeType
        {
            get
            {
                return (Parameters[5].Value is DBNull ? null : Parameters[5].Value) as string;
            }
            set
            {
                Parameters[5].Value = value;
            }
        }

    }

    public class pp_Insert_PaySendLog : SalonPay.DAL.BaseProcedure
    {
        public pp_Insert_PaySendLog()
        {
            spName = "pp_Insert_PaySendLog";
            Parameters = new SqlParameter[9];
            Parameters[0] = new SqlParameter("@LPayGateWayType", SqlDbType.TinyInt, 1);
            Parameters[0].Direction = ParameterDirection.Input;
            Parameters[1] = new SqlParameter("@LMerchantAccId", SqlDbType.VarChar, 50);
            Parameters[1].Direction = ParameterDirection.Input;
            Parameters[2] = new SqlParameter("@LOrderId", SqlDbType.VarChar, 50);
            Parameters[2].Direction = ParameterDirection.Input;
            Parameters[3] = new SqlParameter("@LOrderAmount", SqlDbType.Int, 4);
            Parameters[3].Direction = ParameterDirection.Input;
            Parameters[4] = new SqlParameter("@LOrderTime", SqlDbType.DateTime, 8);
            Parameters[4].Direction = ParameterDirection.Input;
            Parameters[5] = new SqlParameter("@LPayType", SqlDbType.VarChar, 50);
            Parameters[5].Direction = ParameterDirection.Input;
            Parameters[6] = new SqlParameter("@LBgUrl", SqlDbType.VarChar, 50);
            Parameters[6].Direction = ParameterDirection.Input;
            Parameters[7] = new SqlParameter("@LPayerName", SqlDbType.VarChar, 50);
            Parameters[7].Direction = ParameterDirection.Input;
            Parameters[8] = new SqlParameter("@Result", SqlDbType.Int, 4);
            Parameters[8].Direction = ParameterDirection.Output;

        }
        public pp_Insert_PaySendLog(byte _lPayGateWayType, string _lMerchantAccId, string _lOrderId, Int32 _lOrderAmount, DateTime _lOrderTime, string _lPayType, string _lBgUrl, string _lPayerName)
        {
            spName = "pp_Insert_PaySendLog";
            Parameters = new SqlParameter[9];
            Parameters[0] = new SqlParameter("@LPayGateWayType", SqlDbType.TinyInt, 1);
            Parameters[0].Direction = ParameterDirection.Input;
            Parameters[0].Value = _lPayGateWayType;
            Parameters[1] = new SqlParameter("@LMerchantAccId", SqlDbType.VarChar, 50);
            Parameters[1].Direction = ParameterDirection.Input;
            Parameters[1].Value = _lMerchantAccId;
            Parameters[2] = new SqlParameter("@LOrderId", SqlDbType.VarChar, 50);
            Parameters[2].Direction = ParameterDirection.Input;
            Parameters[2].Value = _lOrderId;
            Parameters[3] = new SqlParameter("@LOrderAmount", SqlDbType.Int, 4);
            Parameters[3].Direction = ParameterDirection.Input;
            Parameters[3].Value = _lOrderAmount;
            Parameters[4] = new SqlParameter("@LOrderTime", SqlDbType.DateTime, 8);
            Parameters[4].Direction = ParameterDirection.Input;
            Parameters[4].Value = _lOrderTime;
            Parameters[5] = new SqlParameter("@LPayType", SqlDbType.VarChar, 50);
            Parameters[5].Direction = ParameterDirection.Input;
            Parameters[5].Value = _lPayType;
            Parameters[6] = new SqlParameter("@LBgUrl", SqlDbType.VarChar, 50);
            Parameters[6].Direction = ParameterDirection.Input;
            Parameters[6].Value = _lBgUrl;
            Parameters[7] = new SqlParameter("@LPayerName", SqlDbType.VarChar, 50);
            Parameters[7].Direction = ParameterDirection.Input;
            Parameters[7].Value = _lPayerName;
            Parameters[8] = new SqlParameter("@Result", SqlDbType.Int, 4);
            Parameters[8].Direction = ParameterDirection.Output;
        }
        public byte LPayGateWayType
        {
            get
            {
                return (byte)(Parameters[0].Value is DBNull ? byte.MinValue : Parameters[0].Value);
            }
            set
            {
                Parameters[0].Value = value;
            }
        }
        public string LMerchantAccId
        {
            get
            {
                return (Parameters[1].Value is DBNull ? null : Parameters[1].Value) as string;
            }
            set
            {
                Parameters[1].Value = value;
            }
        }
        public string LOrderId
        {
            get
            {
                return (Parameters[2].Value is DBNull ? null : Parameters[2].Value) as string;
            }
            set
            {
                Parameters[2].Value = value;
            }
        }
        public Int32 LOrderAmount
        {
            get
            {
                return Convert.ToInt32(Parameters[3].Value is DBNull ? null : Parameters[3].Value);
            }
            set
            {
                Parameters[3].Value = value;
            }
        }
        public DateTime LOrderTime
        {
            get
            {
                return Convert.ToDateTime((Parameters[4].Value is DBNull ? null : Parameters[4].Value));
            }
            set
            {
                Parameters[4].Value = value;
            }
        }
        public string LPayType
        {
            get
            {
                return (Parameters[5].Value is DBNull ? null : Parameters[5].Value) as string;
            }
            set
            {
                Parameters[5].Value = value;
            }
        }
        public string LBgUrl
        {
            get
            {
                return (Parameters[6].Value is DBNull ? null : Parameters[6].Value) as string;
            }
            set
            {
                Parameters[6].Value = value;
            }
        }
        public string LPayerName
        {
            get
            {
                return (Parameters[7].Value is DBNull ? null : Parameters[7].Value) as string;
            }
            set
            {
                Parameters[7].Value = value;
            }
        }
        public Int32 Result
        {
            get
            {
                return Convert.ToInt32(Parameters[8].Value is DBNull ? null : Parameters[8].Value);
            }
            set
            {
                Parameters[8].Value = value;
            }
        }

    }

    public class pp_Insert_PayReceiveLog : SalonPay.DAL.BaseProcedure
    {
        public pp_Insert_PayReceiveLog()
        {
            spName = "pp_Insert_PayReceiveLog";
            Parameters = new SqlParameter[15];
            Parameters[0] = new SqlParameter("@LPayGateWayType", SqlDbType.TinyInt, 1);
            Parameters[0].Direction = ParameterDirection.Input;
            Parameters[1] = new SqlParameter("@LMerchantAccId", SqlDbType.VarChar, 50);
            Parameters[1].Direction = ParameterDirection.Input;
            Parameters[2] = new SqlParameter("@LOrderId", SqlDbType.VarChar, 50);
            Parameters[2].Direction = ParameterDirection.Input;
            Parameters[3] = new SqlParameter("@LOrderAmount", SqlDbType.Int, 4);
            Parameters[3].Direction = ParameterDirection.Input;
            Parameters[4] = new SqlParameter("@LOrderTime", SqlDbType.DateTime, 8);
            Parameters[4].Direction = ParameterDirection.Input;
            Parameters[5] = new SqlParameter("@LPayType", SqlDbType.VarChar, 50);
            Parameters[5].Direction = ParameterDirection.Input;
            Parameters[6] = new SqlParameter("@LBgUrl", SqlDbType.VarChar, 50);
            Parameters[6].Direction = ParameterDirection.Input;
            Parameters[7] = new SqlParameter("@LPayGateWayDealId", SqlDbType.VarChar, 50);
            Parameters[7].Direction = ParameterDirection.Input;
            Parameters[8] = new SqlParameter("@LPayGateWayDealDate", SqlDbType.DateTime, 8);
            Parameters[8].Direction = ParameterDirection.Input;
            Parameters[9] = new SqlParameter("@LPayGateWayFee", SqlDbType.Int, 4);
            Parameters[9].Direction = ParameterDirection.Input;
            Parameters[10] = new SqlParameter("@LPayBankId", SqlDbType.VarChar, 50);
            Parameters[10].Direction = ParameterDirection.Input;
            Parameters[11] = new SqlParameter("@LPayBankDealId", SqlDbType.VarChar, 50);
            Parameters[11].Direction = ParameterDirection.Input;
            Parameters[12] = new SqlParameter("@LPayResult", SqlDbType.VarChar, 10);
            Parameters[12].Direction = ParameterDirection.Input;
            Parameters[13] = new SqlParameter("@LErrCode", SqlDbType.VarChar, 50);
            Parameters[13].Direction = ParameterDirection.Input;
            Parameters[14] = new SqlParameter("@Result", SqlDbType.Int, 4);
            Parameters[14].Direction = ParameterDirection.Output;

        }
        public pp_Insert_PayReceiveLog(byte _lPayGateWayType, string _lMerchantAccId, string _lOrderId, Int32 _lOrderAmount, DateTime _lOrderTime, string _lPayType, string _lBgUrl, string _lPayGateWayDealId, DateTime _lPayGateWayDealDate, Int32 _lPayGateWayFee, string _lPayBankId, string _lPayBankDealId, string _lPayResult, string _lErrCode)
        {
            spName = "pp_Insert_PayReceiveLog";
            Parameters = new SqlParameter[15];
            Parameters[0] = new SqlParameter("@LPayGateWayType", SqlDbType.TinyInt, 1);
            Parameters[0].Direction = ParameterDirection.Input;
            Parameters[0].Value = _lPayGateWayType;
            Parameters[1] = new SqlParameter("@LMerchantAccId", SqlDbType.VarChar, 50);
            Parameters[1].Direction = ParameterDirection.Input;
            Parameters[1].Value = _lMerchantAccId;
            Parameters[2] = new SqlParameter("@LOrderId", SqlDbType.VarChar, 50);
            Parameters[2].Direction = ParameterDirection.Input;
            Parameters[2].Value = _lOrderId;
            Parameters[3] = new SqlParameter("@LOrderAmount", SqlDbType.Int, 4);
            Parameters[3].Direction = ParameterDirection.Input;
            Parameters[3].Value = _lOrderAmount;
            Parameters[4] = new SqlParameter("@LOrderTime", SqlDbType.DateTime, 8);
            Parameters[4].Direction = ParameterDirection.Input;
            Parameters[4].Value = _lOrderTime;
            Parameters[5] = new SqlParameter("@LPayType", SqlDbType.VarChar, 50);
            Parameters[5].Direction = ParameterDirection.Input;
            Parameters[5].Value = _lPayType;
            Parameters[6] = new SqlParameter("@LBgUrl", SqlDbType.VarChar, 50);
            Parameters[6].Direction = ParameterDirection.Input;
            Parameters[6].Value = _lBgUrl;
            Parameters[7] = new SqlParameter("@LPayGateWayDealId", SqlDbType.VarChar, 50);
            Parameters[7].Direction = ParameterDirection.Input;
            Parameters[7].Value = _lPayGateWayDealId;
            Parameters[8] = new SqlParameter("@LPayGateWayDealDate", SqlDbType.DateTime, 8);
            Parameters[8].Direction = ParameterDirection.Input;
            Parameters[8].Value = _lPayGateWayDealDate;
            Parameters[9] = new SqlParameter("@LPayGateWayFee", SqlDbType.Int, 4);
            Parameters[9].Direction = ParameterDirection.Input;
            Parameters[9].Value = _lPayGateWayFee;
            Parameters[10] = new SqlParameter("@LPayBankId", SqlDbType.VarChar, 50);
            Parameters[10].Direction = ParameterDirection.Input;
            Parameters[10].Value = _lPayBankId;
            Parameters[11] = new SqlParameter("@LPayBankDealId", SqlDbType.VarChar, 50);
            Parameters[11].Direction = ParameterDirection.Input;
            Parameters[11].Value = _lPayBankDealId;
            Parameters[12] = new SqlParameter("@LPayResult", SqlDbType.VarChar, 10);
            Parameters[12].Direction = ParameterDirection.Input;
            Parameters[12].Value = _lPayResult;
            Parameters[13] = new SqlParameter("@LErrCode", SqlDbType.VarChar, 50);
            Parameters[13].Direction = ParameterDirection.Input;
            Parameters[13].Value = _lErrCode;
            Parameters[14] = new SqlParameter("@Result", SqlDbType.Int, 4);
            Parameters[14].Direction = ParameterDirection.Output;
        }
        public byte LPayGateWayType
        {
            get
            {
                return (byte)(Parameters[0].Value is DBNull ? byte.MinValue : Parameters[0].Value);
            }
            set
            {
                Parameters[0].Value = value;
            }
        }
        public string LMerchantAccId
        {
            get
            {
                return (Parameters[1].Value is DBNull ? null : Parameters[1].Value) as string;
            }
            set
            {
                Parameters[1].Value = value;
            }
        }
        public string LOrderId
        {
            get
            {
                return (Parameters[2].Value is DBNull ? null : Parameters[2].Value) as string;
            }
            set
            {
                Parameters[2].Value = value;
            }
        }
        public Int32 LOrderAmount
        {
            get
            {
                return Convert.ToInt32(Parameters[3].Value is DBNull ? null : Parameters[3].Value);
            }
            set
            {
                Parameters[3].Value = value;
            }
        }
        public DateTime LOrderTime
        {
            get
            {
                return Convert.ToDateTime((Parameters[4].Value is DBNull ? null : Parameters[4].Value));
            }
            set
            {
                Parameters[4].Value = value;
            }
        }
        public string LPayType
        {
            get
            {
                return (Parameters[5].Value is DBNull ? null : Parameters[5].Value) as string;
            }
            set
            {
                Parameters[5].Value = value;
            }
        }
        public string LBgUrl
        {
            get
            {
                return (Parameters[6].Value is DBNull ? null : Parameters[6].Value) as string;
            }
            set
            {
                Parameters[6].Value = value;
            }
        }
        public string LPayGateWayDealId
        {
            get
            {
                return (Parameters[7].Value is DBNull ? null : Parameters[7].Value) as string;
            }
            set
            {
                Parameters[7].Value = value;
            }
        }
        public DateTime LPayGateWayDealDate
        {
            get
            {
                return Convert.ToDateTime((Parameters[8].Value is DBNull ? null : Parameters[8].Value));
            }
            set
            {
                Parameters[8].Value = value;
            }
        }
        public Int32 LPayGateWayFee
        {
            get
            {
                return Convert.ToInt32(Parameters[9].Value is DBNull ? null : Parameters[9].Value);
            }
            set
            {
                Parameters[9].Value = value;
            }
        }
        public string LPayBankId
        {
            get
            {
                return (Parameters[10].Value is DBNull ? null : Parameters[10].Value) as string;
            }
            set
            {
                Parameters[10].Value = value;
            }
        }
        public string LPayBankDealId
        {
            get
            {
                return (Parameters[11].Value is DBNull ? null : Parameters[11].Value) as string;
            }
            set
            {
                Parameters[11].Value = value;
            }
        }
        public string LPayResult
        {
            get
            {
                return (Parameters[12].Value is DBNull ? null : Parameters[12].Value) as string;
            }
            set
            {
                Parameters[12].Value = value;
            }
        }
        public string LErrCode
        {
            get
            {
                return (Parameters[13].Value is DBNull ? null : Parameters[13].Value) as string;
            }
            set
            {
                Parameters[13].Value = value;
            }
        }
        public Int32 Result
        {
            get
            {
                return Convert.ToInt32(Parameters[14].Value is DBNull ? null : Parameters[14].Value);
            }
            set
            {
                Parameters[14].Value = value;
            }
        }

    }

    public class pp_Update_Order : SalonPay.DAL.BaseProcedure
    {
        public pp_Update_Order()
        {
            spName = "pp_Update_Order";
            Parameters = new SqlParameter[3];
            Parameters[0] = new SqlParameter("@OrderId", SqlDbType.VarChar, 50);
            Parameters[0].Direction = ParameterDirection.Input;
            Parameters[1] = new SqlParameter("@Ostatus", SqlDbType.TinyInt, 1);
            Parameters[1].Direction = ParameterDirection.Input;
            Parameters[2] = new SqlParameter("@Result", SqlDbType.Int, 4);
            Parameters[2].Direction = ParameterDirection.Output;

        }
        public pp_Update_Order(string _orderId, byte _ostatus)
        {
            spName = "pp_Update_Order";
            Parameters = new SqlParameter[3];
            Parameters[0] = new SqlParameter("@OrderId", SqlDbType.VarChar, 50);
            Parameters[0].Direction = ParameterDirection.Input;
            Parameters[0].Value = _orderId;
            Parameters[1] = new SqlParameter("@Ostatus", SqlDbType.TinyInt, 1);
            Parameters[1].Direction = ParameterDirection.Input;
            Parameters[1].Value = _ostatus;
            Parameters[2] = new SqlParameter("@Result", SqlDbType.Int, 4);
            Parameters[2].Direction = ParameterDirection.Output;
        }
        public string OrderId
        {
            get
            {
                return (Parameters[0].Value is DBNull ? null : Parameters[0].Value) as string;
            }
            set
            {
                Parameters[0].Value = value;
            }
        }
        public byte Ostatus
        {
            get
            {
                return (byte)(Parameters[1].Value is DBNull ? byte.MinValue : Parameters[1].Value);
            }
            set
            {
                Parameters[1].Value = value;
            }
        }
        public Int32 Result
        {
            get
            {
                return Convert.ToInt32(Parameters[2].Value is DBNull ? null : Parameters[2].Value);
            }
            set
            {
                Parameters[2].Value = value;
            }
        }

    }

    public class pp_Get_Order_ByID : SalonPay.DAL.BaseProcedure
    {
        public pp_Get_Order_ByID()
        {
            spName = "pp_Get_Order_ByID";
            Parameters = new SqlParameter[1];
            Parameters[0] = new SqlParameter("@Orderid", SqlDbType.VarChar, 50);
            Parameters[0].Direction = ParameterDirection.Input;

        }
        public pp_Get_Order_ByID(string _orderid)
        {
            spName = "pp_Get_Order_ByID";
            Parameters = new SqlParameter[1];
            Parameters[0] = new SqlParameter("@Orderid", SqlDbType.VarChar, 50);
            Parameters[0].Direction = ParameterDirection.Input;
            Parameters[0].Value = _orderid;
        }
        public string Orderid
        {
            get
            {
                return (Parameters[0].Value is DBNull ? null : Parameters[0].Value) as string;
            }
            set
            {
                Parameters[0].Value = value;
            }
        }

    }

}